EMT Practice Test

1. Question Content...


Question List

Question1: An Einstein Discovery team created a model to maximize the margin of their sales opportunities. They want to deploy the model to the Opportunity object in order to predict the outcome of every newly created or updated Opportunity.
What are the steps to accomplish this?

Question2: Concurrent queries per user?

Question3: A consultant is tasked with creating one query that shows how many opportunities and cases there are per account.
Cases and opportunities are found in two different datasets with a reference to the related Account via the AccoundId.
What options do the consultant have in Analytics Studio to create the query?

Question4: Max story creations per org per month

Question5: What's the best way to describe the template-info.json file?

Question6: What is the test called that helps to identify categories that exhibit a pattern outside the overall average?

Question7: Universal Containers has a dashboard for Sales Managers to visualize the YoY Growth of their customers- The formula used is: YoY = [(This Year - Last Year) / Last Year] % Based on the graphic, when there is no account in the Last Year column, the YoY Growth shows null results. The Sales Managers want to replace it with 100% value.
What is the correct function to use?

Question8: Mosaic recently hired a new development coordinator, Zoe. First, Danielle grants Zoe the Einstein Analytics Platform license, but Zoe reports that she still can't access Einstein Analytics. What could be the problem?

Question9: What is an Analytics app?

Question10: When deploying a model to an existing Prediction, w number should be considered"1

Question11: What does the Division is Naval section of the waterfall graph tell you?

Question12: In an org, some of the Activity records do not have related Opportunity records. Additionally, there are Opportunity records that do not have related Activity records.
Which SAQL statement will fetch all Opportunities, even if they don't have associated Activities, and fetch related Activity data, if it exists?

Question13: What does XMD stand for?

Question14: In the context of Analytics, what is faceting?

Question15: A consultant built an Einstein Analytics app for the Sales Operations team. The Sales Operations team wants to share their app with other people at the company. The consultant recommends distributing the app as an Einstein Analytics template app.
What can the consultant do to give the Sales team more choices and options with future apps that are generated from the Sales Operations app'

Question16: Universal Containers reports that nay selection in the List widget is not affecting the pie chart in one of their tableau CRM dashboard. They query options associated with the List widget and Pie chart are shown in the graphic Which change can a Tableau CRM Consultant implement to solve this issues, given that the queries are using the same dataset?

Question17: When organizing information in an Einstein Analytics dashboard, what does the "Progressive Disclosure' design principle mean'

Question18: In a dataset, there are multiple boolean fields. When displayed on any dashboard, the boolean fields should all be displayed in the same way: a value of true should result in the display of the word "Yes" in green; a value of false should result in the display of the word "No" in red.
In which two ways can this be accomplished? Choose 2 answers

Question19: What are the two main parts of a lens/exploration?

Question20: How can you restrict access to Analytics data at the row level?

Question21: How many stories can you create in Analytics Plus?

Question22: A customer is reviewing a story that is set to maximize the daily sales quantity of consumer products in stores and sees this chart. The visualized tooltip belongs to the blue bar for San Francisco, reflecting, November daily sales quantities in that city specifically.
What two conclusions can be drawn from this insight?

Question23: An Einstein Analytics consultant is asked to add a new SalesTax field to a Product Sales dataset. The formula to calculate SalesTax is (SubTotal'CountyTax).
Which node should the consultant use in a Dataflow to calculate and insert SalesTax to the dataset?

Question24: A new field called "CardBalance" is added to the standard object. Account. The team wants to add this new field to an Einstein Analytics dataset that sources the Account object; however, the team needs to limit the users who are able to view that field's data in the dataset.
How can an Einstein Consultant help them implement this new requirement?

Question25: Universal Containers (UC) is a multinational company that utilizes Salesforce and has a variety of internal systems. UC uses Einstein Analytics for their data analysis platform and they want to automate their weekly manual process to create a dataset from their on-premise data warehouse. Which solution should a consultant recommend to meet this requirement?

Question26: A large company is rolling out Einstein Analytics to their field sales. They have a well-defined role hierarchy where everyone is assigned to an appropriate node on the hierarchy.
An individual Sales rep should be able to view all opportunities that she/he owns or as part of the account team or opportunity team. The Sales Manager should be able to view all opportunities for the entire Sales team. Similarly, the Sales Vice President should be able to view opportunities for everyone who rolls up in that hierarchy.
The opportunity dataset has a field called 'Ownerld' which represents the opportunity owner.
Given this information, how can an Einstein Consultant implement the above requirements?

Question27: A customer has a dataset consisting of over 300 unique product names. They request a prediction model with the product names included.
Which action should the Einstein Consultant take?

Question28: An Einstein Consultant is reviewing the "Why it Happened" Insights provided by Einstein Discovery with the customer. The customer would like to validate the results. Which action should the consultant take?

Question29: A customer displays a lot of data and wants a way to dynamically emphasize certain values on a bar chart in order to properly grab the user's attention.
What can an Einstein Consultant use to accomplish this task?

Question30: A consultant built an Einstein Analytics app for the Sales Operations team. The team wants to share this app with other people at the company. The consultant recommends distributing the app as an Einstein Analytics template app.
In the process of creating the template, which role does the original Einstein Analytics app for the Sales Operation team play?

Question31: Salesforce Analytics is...

Question32: Yasmine told Danielle she's interested in using the artificial intelligence provided by Einstein Discovery to enhance analysis Mosaic probably wouldn't have considered through their own means. How can Danielle use Einstein Analytics to load data into Einstein Discovery?

Question33: An Einstein Analytics Consultant is working with a subscriptions based company to build a dashboard to understand customer renewals. Each subscription is captured as a Closed Won Opportunity within Salesforce Unfortunately the Opportunity record does not specify whether it is a renewal or a net new subscription.
Which data transformation should be used to determine if a subscription is new or a renewal?

Question34: A consultant built a very useful Einstein Analytics app for Sales Operations, and they want to share its contents with the rest of Global Sales. However, they do not want to add everyone in Sales to their app. The consultant recommends extending the Sales Operations app and distributing it as an Einstein Analytics template app, but needs to locate specific information to get started.

Given the code statement above, which endpoint should it be posted to?

Question35: Permissions of which 2 internal users are used by Analytics to gain access to Salesforce data?

Question36: A consultant built a Tableau CRM dashboard for a shipping company. The consultant enabled data sync (replication) to increase the speed to datasets refreshing.
How often will the data on the dashboard be refreshed?

Question37: In a story investigating margin, large variations between product groups are dominating the story. Which action might an Einstein Consultant take to resolve this?

Question38: The Universal Containers company used Einstein Analytics to create two datasets:
Dataset A: contains a list of activities with an "activitylD" dimension and a "userlD" dimension Dataset B: contains a list of users with a "userlD" dimension The team wants to delete from Dataset A all activities related to users in Dataset B.
How can an Einstein Consultant help them achieve this?

Question39: What are Einstein Analytics prebuilt permission sets? Select 2:

Question40: A dataset is ready for analysis in Einstein Discovery.
What is the first step a consultant should take after the data is loaded?

Question41: What are predictive insights good for?

Question42: Which of the following are included in the template object?

Question43: A Tableau CRM consultant is asked to add a new SalesTax field to a Product Sales dataset. The formula to calculate SalesTax is (SubTotal'CountyTax).
Which node should the consultant use in a recipe to calculate and insert SalesTax to the dataset?

Question44: After getting approval of the dashboard layout design for a desktop, the Einstein Analytics consultant is ready to start the design process for a mobile layout.
What are three considerations that the consultant should keep in mind when developing the layout? Choose 3 answers

Question45: A Tableau CRM consultant has just completed deployment of an analytic app containing a recipe plus several datasets and dashboards. While conducting post deployment a smoke test, the new datasets don't seem to have migrated.
What post migration step has likely been forgotten?
What post migration step has likely been forgotten?

Question46: What are the 3 basic actions within a query in Analytics? Choose 3:

Question47: When you assign any Analytics permission set to users in your org, Salesforce auto-assigns the Analytics Platform permission set license to that user.

Question48: A training dataset Is being prepared for a Einstein Discovery story. One skewed with outliers. at action should the Einstein consultant take?

Question49: A dashboard dataset is growing and the Einstein Analytics consultant notices an impact on performance. The consultant needs to make a few adjustments.
Which three actions can the consultant take to improve dashboard performance? Choose 3 answers

Question50: What kind of insight is "What Is The Difference"?

Question51: Why would you use the Actions menu in a chart?

Question52: Refer to the graphic.

Einstein found a recommendation to improve the story: apparently there are two variables that behave the same. Given there is no additional information, what is the correct action?

Question53: A client has a dashboard for Sales Managers. They want to have a list filter that shows the name of the month. However, based on the "CloseDate_Month" field, the list filter shows numbers instead of names.
How can an Einstein Consultant use the Dataflow nodes to generate the name of month as a new dimension in the dataset?

Question54: What can you change in a Compare Table formula column?

Question55: Which widget property allows a consultant to restrict the view to a domain bounded by the values entered'

Question56: A Tableau CRM consultant develops a dashboard called
SalesPerformance_l in a sardbox environment. To deploy the recipe the consultant creates a package in workbench What is the correct meta data reference in the xml file?

Question57: The Universal Containers company thinks it knows everything about its business. However, Einstein Discovery surfaces an unexpected pattern that is concerning. They call in departmental experts and hold a meeting to discuss next steps with an Einstein Consultant.
What should the consultant advise as the next action'

Question58: Universal Containers has a Dashboard for Sales Managers. They need to visualize their win rate.
Which chart type can be used to keep track if they are below of beyond the target?

Question59: An insurance company has many Einstein Analytics dashboards that show the influence of weather, such as atmospheric temperature, on customer cases. A service agent commented that it is sometimes difficult to determine, by looking at a dashboard, whether the temperature data is reported in degrees Fahrenheit or in degrees Celsius.
How can a dashboard designer ensure the temperature data is easier to interpret on the dashboards?

Question60: How many groupings can you have in a Compare Table?

Question61: What does a configuration wizard do?

Question62: A consultant is asked to configured a user to view a dashboard, within a designated app, without the ability to create and save lenses.
After adding the user to the app, which action should the consultant take to implement this requirement?

Question63: An Einstein Consultant is reviewing the "Why it Happened" Insights provided by Einstein Discovery with the customer. The customer would like to validate the results. Which action should the consultant take?

Question64: What are two main steps for creating a dataset?

Question65: The edgemart transformation gives the dataflow access to an existing, registered dataset that can contain Salesforce data, external data, or a combination of both.
Where is an edgemart transformation specified?

Question66: What are two core design principles to consider when building Analytics apps or dashboards? Choose 2 answers

Question67: The Tableau CRM team at a company has created three dataflows.
myDataflowOne: this dataflow tasks 2 hours to run.
myDataflowOne: this dataflow tasks 1 hours and 30 minutes to run
myDataflowOne: this dataflow tasks 1 minute and 30 seconds to run.
If all three dataflows run, how many count towards the limit?

Question68: Max story creations per org per day:

Question69: After the initial creation of a story, the first story insight explains 93% of the variation of the outcome variable. This is unusual high?
What is the most likely multiple for this?

Question70: The Einstein Analytics Plus Platform license is enabled for a Salesforce org and assigned to each user. However, these users cannot see the Einstein Analytics Studio in the App Launcher.
How can this issue be addressed?

Question71: A consultant wants to optimize data loads by extracting Salesforce objects using independent Einstein Analytics dataflows ahead of time. Which construct should be used to accomplish this?

Question72: A data architect wants to use a dataflow transformation to implement row-level security that is based on role hierarchy in Salesforce. Which transformation should be used to level the dataset hierarch?

Question73: Results from an Einstein Discovary story are reviewed with a business user. They agree with the findings but noticed that none of the fields used in the story have a correlation value greater than 4%. The client is now concerned that the model may not be good enough to next steps?

Question74: A list widget is added to a dashboard with existing charts and tables. What must be true for the list widget to facet the dashboard charts and tables using widget properties?

Question75: A small Business Intelligence team is overwhelmed with multiple requests to create new dashboards. An option is to use layout templates to help with dashboard development.
What are two advantages of using layout templates? Choose 2 answers

Question76: What is an Einstein Discovery story?

Question77: You are asked to update and maintain your company's Einstein Analytics dashboards.
A request comes in for one of the dashboards that contains steps from different datasets. The request is to make it possible for a table from one dataset to be filtered by the results of a chart from another dataset. Your solution is to create a results binding.
Which three steps should you implement to create the binding?

Question78: Max number of dataflow definitions (with data sync enabled)

Question79: A company used Einstein Analytics to create two datasets:
1. "Opportunity With Account- dataset, which contains data from the Opportunity standard object augmented by the Account data.
2. "Case with Account" dataset. which contains data from the Case standard object augmented by the Account data.
The company wants to build a lens showing the total number of Opportunities and Cases per Account. How can a consultant help them build this lens'

Question80: You can get data into Einstein Discovery:

Question81: A Salesforce administrator wants to create a new dashboard that uses custom geoJSON to display data; however, the administrator is unable to upload the file via the UI.
What should be done?

Question82: What can changing an answer to a wizard question do?

Question83: In the Insights list, insights are ranked in what order?

Question84: Which of these is not a method for controlling record-level access?

Question85: Einstein Discovery gives you several different kinds of recommended insights. Which of these insights is descriptive?

Question86: What can you do with the dataflow?

Question87: The client is trying to create a SAQL step to predict sales in each sales region. They cannot get the query to return any results, but have identified that the error is in the time series statement. They have asked an Einstein Consultant to review the following query and fix any errors.

Which timeseries statement will fix the query'

Question88: A Tableau CRM consultant has created three recipes that each produce a dataset.
Recipe1 creates Dataset1.
Recipe2 created Dataset2.
Recipe2 created Dataset3.
Recipe3 is dependent on Dataset1, while Recipe1 and Recipe2 have no dependencies.
How should the consultant implement the recipe schedule?

Question89: A consultant has created a story to maximize the daily sales quantity of consumer products in stores. After creating a story, the consulting is presented with this data alert by Einstein Discovery (see graphic).
What are two appropriate actions to take?
Choose 2 answers

Question90: A company's Salesforce org has multi-currency enabled. This company's business intelligence team used Einstein Analytics to build a dataflow that creates a dataset, "OpportunityDataSet". This dataset is populated with data extracted from the standard object, Opportunity. One of the extracted fields is the standard field, Amount.
If a user explores the "OpportunityDataSet" in Einstein Analytics, in which currency will the Amount values be shown?

Question91: Exhibit:

A company wants to create a timeline chart to visualize the evolution of their Closed Won Opportunities. What are the required parameters to build a lens that displays output similar to the image shown?

Question92: Philip adds a recently created Seed Bank Orders dataset to an Einstein Analytics app for which the Mosaic Seed Bank project team has the Viewer app role. How much data in the Seed Bank Orders dataset can a project team member see?

Question93: A consultant has been brought in to help increase the adaption of Tableau CRM. It has been identified that account managers are struggling to get an overview of their accounts before meeting with them. Ideally they would like to have key details highlighted about active cases and opportunities, opportunity value and product whitespace.
What can the consultant do to increase adoption?

Question94: Number of queries per user per day

Question95: Where can you view the status of a CSV upload in Analytics?

Question96: Yasmine wants to create a lens with the Seed Bank Orders dataset, but she currently doesn't see any rows in the dataset. Since Yasmine is Hadiqa's manager, Yasmine asks Hadiqa if she's experiencing the same problem, but Hadiqa replies that she can see all the rows. Why is this happening?

Question97: Universal Containers is evaluating the connection mode for the objects in their local Salesforce connector. They want to only sync updated and new records from the Order object, but they have some formula fields on the object and want to ensure those are updated weekly.
which
Which connection mode is best suited for this purpose?

Question98: To see predictive insights, what option do you select in the Story toolbar?

Question99: The Einstein Analytics team at a company created a clataset based on the Opportunity__c custom object. The VP of Sales reports seeing the message "No results found" when opening the dataset to explore it. Other users below the VP in the role hierarchy can see rows on the same dataset. Which two problems might be causing this issue?

Question100: Can you share dashboards with others in your org?

Question101: Is there a need for a separate Permission Set Licence for an Analytics app?

Question102: An Einstein Consultant receives a new project from a client that wants to implement Einstein Analytics. They do not currently have Einstein Analytics, but want guidance around how to ensure that their users have correct access.
They have 1000 users with a small team of three people who will build datasets and dashboards. An additional 15 people should be able to create dashboards. The remaining users should only be able to view dashboards.
Which recommendation should the consultant give the client?

Question103: What can you do on the Edit Field Attributes page when uploading a CSV file to Analytics?